UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mPKxlq4GZsiVOaqZPZpDelidR0hDX4AM3sW1aVj9yp4='
WHERE
key_id = '4f9e3708a770280e686b17fda3ae79db5d0d88b5be6e7f00939f32ccf95d1bb6'
AND (
token = 'mPKxlq4GZsiVOaqZPZpDelidR0hDX4AM3sW1aVj9yp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)