UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EjHzkxp1FxLyRg3/1xhiMsgToap6BMw4MbhFvlmwLmE='
WHERE
key_id = 'd9102dad1b46b4a90235f9cc3ea4f189d639603c9f548566c243e4a36045888e'
AND (
token = 'EjHzkxp1FxLyRg3/1xhiMsgToap6BMw4MbhFvlmwLmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)