UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p0v2WOSRGwz88/8am8DY7poEaUEAkYzetytr9mVChsY='
WHERE
key_id = 'afc4914644b87473e713b4d78d97e220a6b10fba55c2c23dccbd322a7be74ef7'
AND (
token = 'p0v2WOSRGwz88/8am8DY7poEaUEAkYzetytr9mVChsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)