UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHzGc1ENSdAUOKk1pjbQWQ44QaD++0Yc+q7aDAy2W+A='
WHERE
key_id = 'd236d36782abda1bc7ee8af267c6067074091d48a318b63fa5a80e417a44dc1a'
AND (
token = 'pHzGc1ENSdAUOKk1pjbQWQ44QaD++0Yc+q7aDAy2W+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)