UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8HZoGZKl0dtRp2QxvmVMCsJjSrq2YAGO5WV6O8KZjBg='
WHERE
key_id = '7d1d07ba886743a4f2700bf4964bed7c0ffad68a68d487d4b7dca6de736130bd'
AND (
token = '8HZoGZKl0dtRp2QxvmVMCsJjSrq2YAGO5WV6O8KZjBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)