UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R9AV+27Q3Bei7wGGCkvwCdzG5MBG9G7TL5vNm/fhAdw='
WHERE
key_id = 'f36731e3169bb7d18a3926965ef275c4d45810e6c95ff4787ee94855c22bd5c8'
AND (
token = 'R9AV+27Q3Bei7wGGCkvwCdzG5MBG9G7TL5vNm/fhAdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)