UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'djsIPew8cc9SpViflzxxHdknqE+vo/2Bbw9Iei3yTf4='
WHERE
key_id = '3a1a264b88c3123197083c7c6cc570034d37eb679f27b2283ed5877a5709f257'
AND (
token = 'djsIPew8cc9SpViflzxxHdknqE+vo/2Bbw9Iei3yTf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)