UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8GamBi8kPHgRZA+F/Sk3LraE4QerGFWXLzfO4hf9aJg='
WHERE
key_id = 'cf479f2bf1b5b6801d8a3c3d5bacc2de0b55e36bc5105a569b1b009f1ddd8392'
AND (
token = '8GamBi8kPHgRZA+F/Sk3LraE4QerGFWXLzfO4hf9aJg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)