UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4B4mCAJbK0K1yI8vHXhXiflBrWZOkoarTptjJfZIXX8='
WHERE
key_id = 'f7412f33a43ae012a5ad55ec002849a733f0da3cf9faa2804cf185098aaf20eb'
AND (
token = '4B4mCAJbK0K1yI8vHXhXiflBrWZOkoarTptjJfZIXX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)