UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9mi3lg+OSc4+f3+IqDBQGLj+k7yL8DYKgA80BQhpbbw='
WHERE
key_id = 'ee6c1db9e375feceae0b09083d420d76baa6d9f536201c7af72f8991f378918b'
AND (
token = '9mi3lg+OSc4+f3+IqDBQGLj+k7yL8DYKgA80BQhpbbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)