UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q16pgAlBee8JrNcCB0PyH8OlEKOK3WhgAjldBWklRQ0='
WHERE
key_id = '18e58b9db11c92def08cea57111187ac799324f4ba9131870a383b0ee7bffe93'
AND (
token = 'Q16pgAlBee8JrNcCB0PyH8OlEKOK3WhgAjldBWklRQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)