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