UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46XRgGBNuvDgU+bcDN2UoHjg6+80lY8SezvBiE1+W9c='
WHERE
key_id = '0cd91fd3279f0121a91f63849e18d43b67ecfbcad71390e4d1f3b22b83f13181'
AND (
token = '46XRgGBNuvDgU+bcDN2UoHjg6+80lY8SezvBiE1+W9c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)