UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/CZCodE5OZkTzU0X2PMCz+ITRqWLzVYVO3MJzn/Q904='
WHERE
key_id = '497977309fc8511524ad75c8d396768f466304ff8ed7f2611190321b4b5619e5'
AND (
token = '/CZCodE5OZkTzU0X2PMCz+ITRqWLzVYVO3MJzn/Q904='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)