UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UZ8xfuzKSM3jIBu8Ms52LM7zefvYHayZ1PJvYAc2CcE='
WHERE
key_id = 'abe625e9d0ac6a9d61e95a54bb06398fa3572b987326213cbd843b5827c7c4c2'
AND (
token = 'UZ8xfuzKSM3jIBu8Ms52LM7zefvYHayZ1PJvYAc2CcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)