UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2SZYHmS3pEYPlf8jR7JgAC7ympypWb4ze6vO4koN/+w='
WHERE
key_id = '4277173a672d7fd8c0ba6cf41d96a0d194dc323ecba686abf33cc702ea2a39e3'
AND (
token = '2SZYHmS3pEYPlf8jR7JgAC7ympypWb4ze6vO4koN/+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)