UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vpyX0QfYgxizSvsLWY6FwHziP2xu0WP5gly2dW1akMg='
WHERE
key_id = '1ae63b1780f2c502fa080316927635be162808b61e0a506891ba3e8607f2cbf0'
AND (
token = 'vpyX0QfYgxizSvsLWY6FwHziP2xu0WP5gly2dW1akMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)