UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KtxOQ2IL5wI7IRx/s5YA0Im0MT+nQDQSCe/N7yE/iTg='
WHERE
key_id = '0afbff8b51d499f7c62071a97b012df35b67311ec2e8248026d2f3c52e30bcad'
AND (
token = 'KtxOQ2IL5wI7IRx/s5YA0Im0MT+nQDQSCe/N7yE/iTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)