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