UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g4NSqu5feNFpITFD5TyRbj5aDrKocV35OHJ167EakiA='
WHERE
key_id = '6225c102e02ac89777249751dcf466419918be252eca836ab5d9f0e12ef139c6'
AND (
token = 'g4NSqu5feNFpITFD5TyRbj5aDrKocV35OHJ167EakiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)