UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YAfCjledgcc6amaTyqMVu4SqZjPcmFxbKGMsRoZjAEg='
WHERE
key_id = '3a1c43a252877814be25b314d2ba882a7837954f0c1f2b7223bf3da74ea5ec60'
AND (
token = 'YAfCjledgcc6amaTyqMVu4SqZjPcmFxbKGMsRoZjAEg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)