UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8GDLC07hcHXu4mrLAyxOaC2YXyokS79bbv3MFFMrC+c='
WHERE
key_id = '8914542d395b7fab35f99234512b631be0224b5f3bd739ceea15072b3022a6bb'
AND (
token = '8GDLC07hcHXu4mrLAyxOaC2YXyokS79bbv3MFFMrC+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)