UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TQyYD18uNl5wBhKrQBVklsQ88iOImVlEA4o0tQU6drQ='
WHERE
key_id = '459613e6ecd0d65866225174701e36c6f5d73407bdc271b7ba671b9b38c0df1d'
AND (
token = 'TQyYD18uNl5wBhKrQBVklsQ88iOImVlEA4o0tQU6drQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)