UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fAgXyxGjuY+2qmJdaTnkCGtjhFXm4VfS1oeqMfIKkUg='
WHERE
key_id = '490eee1c14c3c595ae6caac54df5e6b8c99ff012ff742b9538d750e6cc9d72dd'
AND (
token = 'fAgXyxGjuY+2qmJdaTnkCGtjhFXm4VfS1oeqMfIKkUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)