UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XNGIdVyy+dif2fKsUzhiGOtPaheK3xSSHBnahAYJgy4='
WHERE
key_id = '5157ab63a81aa1bf5838e83de40b6a14969ea450181f2f4d49220945705c7670'
AND (
token = 'XNGIdVyy+dif2fKsUzhiGOtPaheK3xSSHBnahAYJgy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)