UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QN1hxALOpBrdLtsuIIWZBtFIA+3vmXCxDsoj9ORCQkM='
WHERE
key_id = '6d4b2a24c3e1b2212f7d586c4365c4b62d2b5c4e114a49a8f101b9c444dd47f4'
AND (
token = 'QN1hxALOpBrdLtsuIIWZBtFIA+3vmXCxDsoj9ORCQkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)