UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p4w6OIo9HGruxbCQmTRyvbxo52iYiOq3+tEhgVjAJPU='
WHERE
key_id = 'ddf7b9e13ad425257a2d161aa573c4ee4f8bcc7273431940ab3f4e3da3cc71c8'
AND (
token = 'p4w6OIo9HGruxbCQmTRyvbxo52iYiOq3+tEhgVjAJPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)