UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cSmTLsPoz4mSsgmx9pSyweSt8ctZ9XCleI8bjYxnQR8='
WHERE
key_id = '31d26063c90818728ae08dd613cfab951cd194088f847825606c88782d303cda'
AND (
token = 'cSmTLsPoz4mSsgmx9pSyweSt8ctZ9XCleI8bjYxnQR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)