UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'usCHt0ehDIzwLDWVGvu9601rqSgkJd62WR2BmKEaBJE='
WHERE
key_id = '4147d81f98d186660ee75d1dd9dd1e82c551c271b5e1d39855f6d67454ddfde8'
AND (
token = 'usCHt0ehDIzwLDWVGvu9601rqSgkJd62WR2BmKEaBJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)