UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YDTu8UhLz9pqzuTqXqwmrWHF3xqzA5m+PwpsVaPFlV4='
WHERE
key_id = 'cd97a6ba80594d5637e84f9c996b907c2637e8f79a3b765a612b5a9117f54b18'
AND (
token = 'YDTu8UhLz9pqzuTqXqwmrWHF3xqzA5m+PwpsVaPFlV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)