UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GjMdv9J3M2pW7Q/q0E1gLQssiyVGCCqeSHo6NNfciqE='
WHERE
key_id = '653c424ae70a46cc46fedc2e8054fc2e1ea80973b7a8e8a59a7d897c21a70709'
AND (
token = 'GjMdv9J3M2pW7Q/q0E1gLQssiyVGCCqeSHo6NNfciqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)