UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+a8p2h7sT2DNWF/vU47ezAwQC8zMEdIFCd4+aggOuvE='
WHERE
key_id = 'ccbbbf63bec4cb72cda4717f265752ed31792e4b536eda9ef7937d783c7204c6'
AND (
token = '+a8p2h7sT2DNWF/vU47ezAwQC8zMEdIFCd4+aggOuvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)