UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8GoLrX5VTh1KM4MHLaJewsL9tID8vx25/KpVNpVeDS8='
WHERE
key_id = '547c2b0ecaa99d30bdcf7c9443cbfd7e7d645c9e62f21f70f93b97efdf0a620f'
AND (
token = '8GoLrX5VTh1KM4MHLaJewsL9tID8vx25/KpVNpVeDS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)