UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X/z8Hlcm8AaepPBlpiRo8Cilm4lEKkFqf5lZJSO6GcI='
WHERE
key_id = '0d95bb1ebdc3fe3f9c74b2e2b198c4ad2852d3e877f3f1cbd0a082c7c38a49cd'
AND (
token = 'X/z8Hlcm8AaepPBlpiRo8Cilm4lEKkFqf5lZJSO6GcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)