UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xcpj5VvCy17NIpOl0V8nDMam9n0LTSZ2T5dub9sj294='
WHERE
key_id = '9bee665956e654005800e7a4ab329766c6bb588bc3d8ee86899aa40db1900c80'
AND (
token = 'Xcpj5VvCy17NIpOl0V8nDMam9n0LTSZ2T5dub9sj294='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)