UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xn3/1R0qqFjakUIfO1TxTKr1/275KbqZ82TNbqKODOw='
WHERE
key_id = 'ea69f2b5431337d858daac28c77c3d493a1703893094a2a3e7fe4ac7a5913d58'
AND (
token = 'Xn3/1R0qqFjakUIfO1TxTKr1/275KbqZ82TNbqKODOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)