UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NDPDLmN0CjqfeTuWKy274liMQLJ7Bdv1eMJ2oigO0TA='
WHERE
key_id = 'a7a8f2d54ef0dbbea9ac42ed21c66cc93d699c9f5ae89268495b3ea785001ebc'
AND (
token = 'NDPDLmN0CjqfeTuWKy274liMQLJ7Bdv1eMJ2oigO0TA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)