UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Adl4hFfuzA9sGCmZJ7Y7CDfXRDGJ6cOQBX78bCbMmk='
WHERE
key_id = 'd2801a5e1d56b16c642f70545b6101b7070132a77269feb086aaf97882dd37e8'
AND (
token = '3Adl4hFfuzA9sGCmZJ7Y7CDfXRDGJ6cOQBX78bCbMmk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)