UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3OBccZMze1IWAlZzfmxL04LTZ6mSR0NGfK+SThzc1q8='
WHERE
key_id = 'c9c3c797c835851369629dd5f612e84a669ee68e2e542c85b17f70941f79f986'
AND (
token = '3OBccZMze1IWAlZzfmxL04LTZ6mSR0NGfK+SThzc1q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)