UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vnVyTjyplBO5y7JmDcYfoeG3SGkSIJhYtcsyQJUAJLc='
WHERE
key_id = 'f2058a3c6e3e94f2a02b1c8990469243bbf07f34f24ed37b3c6efc8f258b03ae'
AND (
token = 'vnVyTjyplBO5y7JmDcYfoeG3SGkSIJhYtcsyQJUAJLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)