UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4ghZQ2X25lJT7h9Sa49xlKc2J+3AA+prKrb3BJbkgS4='
WHERE
key_id = '1fbe36372ab50dc5afd808f24e523a84bdba420fa90f36a498f66025652ec408'
AND (
token = '4ghZQ2X25lJT7h9Sa49xlKc2J+3AA+prKrb3BJbkgS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)