UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RKFIIQS5Emq3MWaOv/W017RNtS3Uqb+uNl0y50eTN8U='
WHERE
key_id = 'd31791b5e88648e13c647646ed14a98b780b85bd8038f4da59227f7c433c20b1'
AND (
token = 'RKFIIQS5Emq3MWaOv/W017RNtS3Uqb+uNl0y50eTN8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)