UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vUmi6uFuPV57qTseAmMpDM4wh6/c4Fh5plN/iwFRtC4='
WHERE
key_id = '4f4a736c5cfcbdfc548a741ff5c958ae77396a18e1f3cf3b1b278a75e4696a58'
AND (
token = 'vUmi6uFuPV57qTseAmMpDM4wh6/c4Fh5plN/iwFRtC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)